1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="POS_DBDataSet" targetNamespace="http://tempuri.org/POS_DBDataSet.xsd" xmlns:mstns="http://tempuri.org/POS_DBDataSet.xsd" xmlns="http://tempuri.org/POS_DBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="POS_DBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="POS_DBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Sales_and_Inventory_System__Gadgets_Shop_.Properties.Settings.GlobalReference.Default.POS_DBConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryTableAdapter" GeneratorDataComponentClassName="CategoryTableAdapter" Name="Category" UserDataComponentName="CategoryTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[Category] WHERE (([ID] = @Original_ID) AND ([CategoryName] = @Original_CategoryName))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
19 </Parameters>
20 </DbCommand>
21 </DeleteCommand>
22 <InsertCommand>
23 <DbCommand CommandType="Text" ModifiedByUser="false">
24 <CommandText>INSERT INTO [dbo].[Category] ([CategoryName]) VALUES (@CategoryName);
25 SELECT ID, CategoryName FROM Category WHERE (ID = SCOPE_IDENTITY())</CommandText>
26 <Parameters>
27 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
28 </Parameters>
29 </DbCommand>
30 </InsertCommand>
31 <SelectCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>SELECT ID, CategoryName FROM dbo.Category</CommandText>
34 <Parameters />
35 </DbCommand>
36 </SelectCommand>
37 <UpdateCommand>
38 <DbCommand CommandType="Text" ModifiedByUser="false">
39 <CommandText>UPDATE [dbo].[Category] SET [CategoryName] = @CategoryName WHERE (([ID] = @Original_ID) AND ([CategoryName] = @Original_CategoryName));
40 SELECT ID, CategoryName FROM Category WHERE (ID = @ID)</CommandText>
41 <Parameters>
42 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
43 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
44 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
45 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="[C:\USERS\RAJ\DESKTOP\POS\SALES AND INVENTORY SYSTEM (GADGETS SHOP)\BIN\DEBUG\POS_DB.MDF].dbo.Category" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
46 </Parameters>
47 </DbCommand>
48 </UpdateCommand>
49 </DbSource>
50 </MainSource>
51 <Mappings>
52 <Mapping SourceColumn="ID" DataSetColumn="ID" />
53 <Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
54 </Mappings>
55 <Sources />
56 </TableAdapter>
57 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
58 <MainSource>
59 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
60 <DeleteCommand>
61 <DbCommand CommandType="Text" ModifiedByUser="false">
62 <CommandText>DELETE FROM [dbo].[Customer] WHERE (([CustomerId] = @Original_CustomerId) AND ([CustomerName] = @Original_CustomerName) AND ([City] = @Original_City) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_ContactNo1 = 1 AND [ContactNo1] IS NULL) OR ([ContactNo1] = @Original_ContactNo1)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)))</CommandText>
63 <Parameters>
64 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
65 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Original" />
66 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
67 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
68 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactNo1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="true" SourceVersion="Original" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Original" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
72 </Parameters>
73 </DbCommand>
74 </DeleteCommand>
75 <InsertCommand>
76 <DbCommand CommandType="Text" ModifiedByUser="false">
77 <CommandText>INSERT INTO [dbo].[Customer] ([CustomerId], [CustomerName], [Address], [City], [ContactNo], [ContactNo1], [Email], [Notes]) VALUES (@CustomerId, @CustomerName, @Address, @City, @ContactNo, @ContactNo1, @Email, @Notes);
78 SELECT CustomerId, CustomerName, Address, City, ContactNo, ContactNo1, Email, Notes FROM Customer WHERE (CustomerId = @CustomerId)</CommandText>
79 <Parameters>
80 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
81 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Current" />
82 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
83 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
84 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
85 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Current" />
86 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
88 </Parameters>
89 </DbCommand>
90 </InsertCommand>
91 <SelectCommand>
92 <DbCommand CommandType="Text" ModifiedByUser="false">
93 <CommandText>SELECT CustomerId, CustomerName, Address, City, ContactNo, ContactNo1, Email, Notes FROM dbo.Customer</CommandText>
94 <Parameters />
95 </DbCommand>
96 </SelectCommand>
97 <UpdateCommand>
98 <DbCommand CommandType="Text" ModifiedByUser="false">
99 <CommandText>UPDATE [dbo].[Customer] SET [CustomerId] = @CustomerId, [CustomerName] = @CustomerName, [Address] = @Address, [City] = @City, [ContactNo] = @ContactNo, [ContactNo1] = @ContactNo1, [Email] = @Email, [Notes] = @Notes WHERE (([CustomerId] = @Original_CustomerId) AND ([CustomerName] = @Original_CustomerName) AND ([City] = @Original_City) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_ContactNo1 = 1 AND [ContactNo1] IS NULL) OR ([ContactNo1] = @Original_ContactNo1)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)));
100 SELECT CustomerId, CustomerName, Address, City, ContactNo, ContactNo1, Email, Notes FROM Customer WHERE (CustomerId = @CustomerId)</CommandText>
101 <Parameters>
102 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
103 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Current" />
104 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
105 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
106 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
107 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Current" />
108 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
109 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
110 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
111 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerName" SourceColumnNullMapping="false" SourceVersion="Original" />
112 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
113 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
114 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactNo1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="true" SourceVersion="Original" />
115 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Original" />
116 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
117 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
118 </Parameters>
119 </DbCommand>
120 </UpdateCommand>
121 </DbSource>
122 </MainSource>
123 <Mappings>
124 <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
125 <Mapping SourceColumn="CustomerName" DataSetColumn="CustomerName" />
126 <Mapping SourceColumn="Address" DataSetColumn="Address" />
127 <Mapping SourceColumn="City" DataSetColumn="City" />
128 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
129 <Mapping SourceColumn="ContactNo1" DataSetColumn="ContactNo1" />
130 <Mapping SourceColumn="Email" DataSetColumn="Email" />
131 <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
132 </Mappings>
133 <Sources />
134 </TableAdapter>
135 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Invoice_InfoTableAdapter" GeneratorDataComponentClassName="Invoice_InfoTableAdapter" Name="Invoice_Info" UserDataComponentName="Invoice_InfoTableAdapter">
136 <MainSource>
137 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Invoice_Info" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
138 <DeleteCommand>
139 <DbCommand CommandType="Text" ModifiedByUser="false">
140 <CommandText>DELETE FROM [dbo].[Invoice_Info] WHERE (([InvoiceNo] = @Original_InvoiceNo) AND ([InvoiceDate] = @Original_InvoiceDate) AND ([CustomerID] = @Original_CustomerID) AND ([SubTotal] = @Original_SubTotal) AND ([VATPer] = @Original_VATPer) AND ([VATAmount] = @Original_VATAmount) AND ([DiscountPer] = @Original_DiscountPer) AND ([DiscountAmount] = @Original_DiscountAmount) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPayment] = @Original_TotalPayment) AND ([PaymentDue] = @Original_PaymentDue) AND ([PaymentType] = @Original_PaymentType) AND ([Status] = @Original_Status))</CommandText>
141 <Parameters>
142 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Original" />
143 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
144 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
145 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
146 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_VATPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Original" />
147 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_VATAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
148 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiscountPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
149 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
150 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_GrandTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
151 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalPayment" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
152 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PaymentDue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Original" />
153 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
154 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
155 </Parameters>
156 </DbCommand>
157 </DeleteCommand>
158 <InsertCommand>
159 <DbCommand CommandType="Text" ModifiedByUser="false">
160 <CommandText>INSERT INTO [dbo].[Invoice_Info] ([InvoiceNo], [InvoiceDate], [CustomerID], [SubTotal], [VATPer], [VATAmount], [DiscountPer], [DiscountAmount], [GrandTotal], [TotalPayment], [PaymentDue], [PaymentType], [Status]) VALUES (@InvoiceNo, @InvoiceDate, @CustomerID, @SubTotal, @VATPer, @VATAmount, @DiscountPer, @DiscountAmount, @GrandTotal, @TotalPayment, @PaymentDue, @PaymentType, @Status);
161 SELECT InvoiceNo, InvoiceDate, CustomerID, SubTotal, VATPer, VATAmount, DiscountPer, DiscountAmount, GrandTotal, TotalPayment, PaymentDue, PaymentType, Status FROM Invoice_Info WHERE (InvoiceNo = @InvoiceNo)</CommandText>
162 <Parameters>
163 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
164 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
165 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
166 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
167 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@VATPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Current" />
168 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@VATAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
169 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiscountPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
170 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
171 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@GrandTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
172 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalPayment" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
173 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PaymentDue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Current" />
174 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
175 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
176 </Parameters>
177 </DbCommand>
178 </InsertCommand>
179 <SelectCommand>
180 <DbCommand CommandType="Text" ModifiedByUser="false">
181 <CommandText>SELECT InvoiceNo, InvoiceDate, CustomerID, SubTotal, VATPer, VATAmount, DiscountPer, DiscountAmount, GrandTotal, TotalPayment, PaymentDue, PaymentType, Status FROM dbo.Invoice_Info</CommandText>
182 <Parameters />
183 </DbCommand>
184 </SelectCommand>
185 <UpdateCommand>
186 <DbCommand CommandType="Text" ModifiedByUser="false">
187 <CommandText>UPDATE [dbo].[Invoice_Info] SET [InvoiceNo] = @InvoiceNo, [InvoiceDate] = @InvoiceDate, [CustomerID] = @CustomerID, [SubTotal] = @SubTotal, [VATPer] = @VATPer, [VATAmount] = @VATAmount, [DiscountPer] = @DiscountPer, [DiscountAmount] = @DiscountAmount, [GrandTotal] = @GrandTotal, [TotalPayment] = @TotalPayment, [PaymentDue] = @PaymentDue, [PaymentType] = @PaymentType, [Status] = @Status WHERE (([InvoiceNo] = @Original_InvoiceNo) AND ([InvoiceDate] = @Original_InvoiceDate) AND ([CustomerID] = @Original_CustomerID) AND ([SubTotal] = @Original_SubTotal) AND ([VATPer] = @Original_VATPer) AND ([VATAmount] = @Original_VATAmount) AND ([DiscountPer] = @Original_DiscountPer) AND ([DiscountAmount] = @Original_DiscountAmount) AND ([GrandTotal] = @Original_GrandTotal) AND ([TotalPayment] = @Original_TotalPayment) AND ([PaymentDue] = @Original_PaymentDue) AND ([PaymentType] = @Original_PaymentType) AND ([Status] = @Original_Status));
188 SELECT InvoiceNo, InvoiceDate, CustomerID, SubTotal, VATPer, VATAmount, DiscountPer, DiscountAmount, GrandTotal, TotalPayment, PaymentDue, PaymentType, Status FROM Invoice_Info WHERE (InvoiceNo = @InvoiceNo)</CommandText>
189 <Parameters>
190 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
191 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
192 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Current" />
193 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
194 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@VATPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Current" />
195 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@VATAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
196 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiscountPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Current" />
197 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
198 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@GrandTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
199 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalPayment" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
200 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PaymentDue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Current" />
201 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Current" />
202 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
203 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Original" />
204 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
205 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="false" SourceVersion="Original" />
206 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
207 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_VATPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATPer" SourceColumnNullMapping="false" SourceVersion="Original" />
208 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_VATAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="VATAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
209 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiscountPer" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountPer" SourceColumnNullMapping="false" SourceVersion="Original" />
210 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiscountAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiscountAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
211 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_GrandTotal" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
212 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalPayment" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
213 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PaymentDue" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaymentDue" SourceColumnNullMapping="false" SourceVersion="Original" />
214 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PaymentType" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PaymentType" SourceColumnNullMapping="false" SourceVersion="Original" />
215 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
216 </Parameters>
217 </DbCommand>
218 </UpdateCommand>
219 </DbSource>
220 </MainSource>
221 <Mappings>
222 <Mapping SourceColumn="InvoiceNo" DataSetColumn="InvoiceNo" />
223 <Mapping SourceColumn="InvoiceDate" DataSetColumn="InvoiceDate" />
224 <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
225 <Mapping SourceColumn="SubTotal" DataSetColumn="SubTotal" />
226 <Mapping SourceColumn="VATPer" DataSetColumn="VATPer" />
227 <Mapping SourceColumn="VATAmount" DataSetColumn="VATAmount" />
228 <Mapping SourceColumn="DiscountPer" DataSetColumn="DiscountPer" />
229 <Mapping SourceColumn="DiscountAmount" DataSetColumn="DiscountAmount" />
230 <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
231 <Mapping SourceColumn="TotalPayment" DataSetColumn="TotalPayment" />
232 <Mapping SourceColumn="PaymentDue" DataSetColumn="PaymentDue" />
233 <Mapping SourceColumn="PaymentType" DataSetColumn="PaymentType" />
234 <Mapping SourceColumn="Status" DataSetColumn="Status" />
235 </Mappings>
236 <Sources />
237 </TableAdapter>
238 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter">
239 <MainSource>
240 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Product" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
241 <DeleteCommand>
242 <DbCommand CommandType="Text" ModifiedByUser="false">
243 <CommandText>DELETE FROM [dbo].[Product] WHERE (([ProductID] = @Original_ProductID) AND ([CategoryID] = @Original_CategoryID) AND ([SubCategoryID] = @Original_SubCategoryID) AND ([Price] = @Original_Price))</CommandText>
244 <Parameters>
245 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
246 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
247 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
248 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
249 </Parameters>
250 </DbCommand>
251 </DeleteCommand>
252 <InsertCommand>
253 <DbCommand CommandType="Text" ModifiedByUser="false">
254 <CommandText>INSERT INTO [dbo].[Product] ([ProductID], [ProductName], [CategoryID], [SubCategoryID], [Features], [Price], [Image]) VALUES (@ProductID, @ProductName, @CategoryID, @SubCategoryID, @Features, @Price, @Image);
255 SELECT ProductID, ProductName, CategoryID, SubCategoryID, Features, Price, Image FROM Product WHERE (ProductID = @ProductID)</CommandText>
256 <Parameters>
257 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
258 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
259 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
260 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
261 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Features" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Features" SourceColumnNullMapping="false" SourceVersion="Current" />
262 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
263 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
264 </Parameters>
265 </DbCommand>
266 </InsertCommand>
267 <SelectCommand>
268 <DbCommand CommandType="Text" ModifiedByUser="false">
269 <CommandText>SELECT ProductID, ProductName, CategoryID, SubCategoryID, Features, Price, Image FROM dbo.Product</CommandText>
270 <Parameters />
271 </DbCommand>
272 </SelectCommand>
273 <UpdateCommand>
274 <DbCommand CommandType="Text" ModifiedByUser="false">
275 <CommandText>UPDATE [dbo].[Product] SET [ProductID] = @ProductID, [ProductName] = @ProductName, [CategoryID] = @CategoryID, [SubCategoryID] = @SubCategoryID, [Features] = @Features, [Price] = @Price, [Image] = @Image WHERE (([ProductID] = @Original_ProductID) AND ([CategoryID] = @Original_CategoryID) AND ([SubCategoryID] = @Original_SubCategoryID) AND ([Price] = @Original_Price));
276 SELECT ProductID, ProductName, CategoryID, SubCategoryID, Features, Price, Image FROM Product WHERE (ProductID = @ProductID)</CommandText>
277 <Parameters>
278 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
279 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
280 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
281 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
282 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Features" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Features" SourceColumnNullMapping="false" SourceVersion="Current" />
283 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
284 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
285 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
286 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
287 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SubCategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubCategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
288 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
289 </Parameters>
290 </DbCommand>
291 </UpdateCommand>
292 </DbSource>
293 </MainSource>
294 <Mappings>
295 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
296 <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
297 <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
298 <Mapping SourceColumn="SubCategoryID" DataSetColumn="SubCategoryID" />
299 <Mapping SourceColumn="Features" DataSetColumn="Features" />
300 <Mapping SourceColumn="Price" DataSetColumn="Price" />
301 <Mapping SourceColumn="Image" DataSetColumn="Image" />
302 </Mappings>
303 <Sources />
304 </TableAdapter>
305 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductSoldTableAdapter" GeneratorDataComponentClassName="ProductSoldTableAdapter" Name="ProductSold" UserDataComponentName="ProductSoldTableAdapter">
306 <MainSource>
307 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.ProductSold" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
308 <DeleteCommand>
309 <DbCommand CommandType="Text" ModifiedByUser="false">
310 <CommandText>DELETE FROM [dbo].[ProductSold] WHERE (([Id] = @Original_Id) AND ([InvoiceNo] = @Original_InvoiceNo) AND ([ProductID] = @Original_ProductID) AND ([ProductName] = @Original_ProductName) AND ([Price] = @Original_Price) AND ([Quantity] = @Original_Quantity) AND ([TotalAmount] = @Original_TotalAmount))</CommandText>
311 <Parameters>
312 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
313 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Original" />
314 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
315 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
316 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
317 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
318 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
319 </Parameters>
320 </DbCommand>
321 </DeleteCommand>
322 <InsertCommand>
323 <DbCommand CommandType="Text" ModifiedByUser="false">
324 <CommandText>INSERT INTO [dbo].[ProductSold] ([InvoiceNo], [ProductID], [ProductName], [Price], [Quantity], [TotalAmount]) VALUES (@InvoiceNo, @ProductID, @ProductName, @Price, @Quantity, @TotalAmount);
325 SELECT Id, InvoiceNo, ProductID, ProductName, Price, Quantity, TotalAmount FROM ProductSold WHERE (Id = SCOPE_IDENTITY())</CommandText>
326 <Parameters>
327 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
328 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
329 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
330 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
331 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
332 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
333 </Parameters>
334 </DbCommand>
335 </InsertCommand>
336 <SelectCommand>
337 <DbCommand CommandType="Text" ModifiedByUser="false">
338 <CommandText>SELECT Id, InvoiceNo, ProductID, ProductName, Price, Quantity, TotalAmount FROM dbo.ProductSold</CommandText>
339 <Parameters />
340 </DbCommand>
341 </SelectCommand>
342 <UpdateCommand>
343 <DbCommand CommandType="Text" ModifiedByUser="false">
344 <CommandText>UPDATE [dbo].[ProductSold] SET [InvoiceNo] = @InvoiceNo, [ProductID] = @ProductID, [ProductName] = @ProductName, [Price] = @Price, [Quantity] = @Quantity, [TotalAmount] = @TotalAmount WHERE (([Id] = @Original_Id) AND ([InvoiceNo] = @Original_InvoiceNo) AND ([ProductID] = @Original_ProductID) AND ([ProductName] = @Original_ProductName) AND ([Price] = @Original_Price) AND ([Quantity] = @Original_Quantity) AND ([TotalAmount] = @Original_TotalAmount));
345 SELECT Id, InvoiceNo, ProductID, ProductName, Price, Quantity, TotalAmount FROM ProductSold WHERE (Id = @Id)</CommandText>
346 <Parameters>
347 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Current" />
348 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
349 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
350 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
351 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
352 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
353 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
354 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_InvoiceNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="InvoiceNo" SourceColumnNullMapping="false" SourceVersion="Original" />
355 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
356 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
357 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
358 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
359 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
360 <Parameter AllowDbNull="false" AutogeneratedName="Id" ColumnName="Id" DataSourceName="[C:\USERS\RAJ\DESKTOP\POS\SALES AND INVENTORY SYSTEM (GADGETS SHOP)\BIN\DEBUG\POS_DB.MDF].dbo.ProductSold" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
361 </Parameters>
362 </DbCommand>
363 </UpdateCommand>
364 </DbSource>
365 </MainSource>
366 <Mappings>
367 <Mapping SourceColumn="Id" DataSetColumn="Id" />
368 <Mapping SourceColumn="InvoiceNo" DataSetColumn="InvoiceNo" />
369 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
370 <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
371 <Mapping SourceColumn="Price" DataSetColumn="Price" />
372 <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
373 <Mapping SourceColumn="TotalAmount" DataSetColumn="TotalAmount" />
374 </Mappings>
375 <Sources />
376 </TableAdapter>
377 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RegistrationTableAdapter" GeneratorDataComponentClassName="RegistrationTableAdapter" Name="Registration" UserDataComponentName="RegistrationTableAdapter">
378 <MainSource>
379 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Registration" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
380 <DeleteCommand>
381 <DbCommand CommandType="Text" ModifiedByUser="false">
382 <CommandText>DELETE FROM [dbo].[Registration] WHERE (([UserName] = @Original_UserName) AND ([Password] = @Original_Password) AND ([Name] = @Original_Name) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_JoiningDate = 1 AND [JoiningDate] IS NULL) OR ([JoiningDate] = @Original_JoiningDate)))</CommandText>
383 <Parameters>
384 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Original" />
385 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
386 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
387 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
388 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
389 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
390 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JoiningDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="true" SourceVersion="Original" />
391 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_JoiningDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Original" />
392 </Parameters>
393 </DbCommand>
394 </DeleteCommand>
395 <InsertCommand>
396 <DbCommand CommandType="Text" ModifiedByUser="false">
397 <CommandText>INSERT INTO [dbo].[Registration] ([UserName], [Password], [Name], [ContactNo], [Email], [JoiningDate]) VALUES (@UserName, @Password, @Name, @ContactNo, @Email, @JoiningDate);
398 SELECT UserName, Password, Name, ContactNo, Email, JoiningDate FROM Registration WHERE (UserName = @UserName)</CommandText>
399 <Parameters>
400 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
401 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
402 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
403 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
404 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
405 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@JoiningDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Current" />
406 </Parameters>
407 </DbCommand>
408 </InsertCommand>
409 <SelectCommand>
410 <DbCommand CommandType="Text" ModifiedByUser="false">
411 <CommandText>SELECT UserName, Password, Name, ContactNo, Email, JoiningDate FROM dbo.Registration</CommandText>
412 <Parameters />
413 </DbCommand>
414 </SelectCommand>
415 <UpdateCommand>
416 <DbCommand CommandType="Text" ModifiedByUser="false">
417 <CommandText>UPDATE [dbo].[Registration] SET [UserName] = @UserName, [Password] = @Password, [Name] = @Name, [ContactNo] = @ContactNo, [Email] = @Email, [JoiningDate] = @JoiningDate WHERE (([UserName] = @Original_UserName) AND ([Password] = @Original_Password) AND ([Name] = @Original_Name) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_JoiningDate = 1 AND [JoiningDate] IS NULL) OR ([JoiningDate] = @Original_JoiningDate)));
418 SELECT UserName, Password, Name, ContactNo, Email, JoiningDate FROM Registration WHERE (UserName = @UserName)</CommandText>
419 <Parameters>
420 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Current" />
421 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
422 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
423 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
424 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
425 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@JoiningDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Current" />
426 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="false" SourceVersion="Original" />
427 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
428 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
429 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
430 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
431 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
432 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_JoiningDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="true" SourceVersion="Original" />
433 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_JoiningDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="JoiningDate" SourceColumnNullMapping="false" SourceVersion="Original" />
434 </Parameters>
435 </DbCommand>
436 </UpdateCommand>
437 </DbSource>
438 </MainSource>
439 <Mappings>
440 <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
441 <Mapping SourceColumn="Password" DataSetColumn="Password" />
442 <Mapping SourceColumn="Name" DataSetColumn="Name" />
443 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
444 <Mapping SourceColumn="Email" DataSetColumn="Email" />
445 <Mapping SourceColumn="JoiningDate" DataSetColumn="JoiningDate" />
446 </Mappings>
447 <Sources />
448 </TableAdapter>
449 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StockTableAdapter" GeneratorDataComponentClassName="StockTableAdapter" Name="Stock" UserDataComponentName="StockTableAdapter">
450 <MainSource>
451 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Stock" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
452 <DeleteCommand>
453 <DbCommand CommandType="Text" ModifiedByUser="false">
454 <CommandText>DELETE FROM [dbo].[Stock] WHERE (([StockID] = @Original_StockID) AND ([StockDate] = @Original_StockDate) AND ([ProductID] = @Original_ProductID) AND ([SupplierID] = @Original_SupplierID) AND ([Quantity] = @Original_Quantity))</CommandText>
455 <Parameters>
456 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StockID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Original" />
457 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StockDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockDate" SourceColumnNullMapping="false" SourceVersion="Original" />
458 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
459 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
460 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
461 </Parameters>
462 </DbCommand>
463 </DeleteCommand>
464 <InsertCommand>
465 <DbCommand CommandType="Text" ModifiedByUser="false">
466 <CommandText>INSERT INTO [dbo].[Stock] ([StockID], [StockDate], [ProductID], [SupplierID], [Quantity]) VALUES (@StockID, @StockDate, @ProductID, @SupplierID, @Quantity);
467 SELECT StockID, StockDate, ProductID, SupplierID, Quantity FROM Stock WHERE (StockID = @StockID)</CommandText>
468 <Parameters>
469 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StockID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Current" />
470 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StockDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockDate" SourceColumnNullMapping="false" SourceVersion="Current" />
471 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
472 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
473 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
474 </Parameters>
475 </DbCommand>
476 </InsertCommand>
477 <SelectCommand>
478 <DbCommand CommandType="Text" ModifiedByUser="false">
479 <CommandText>SELECT StockID, StockDate, ProductID, SupplierID, Quantity FROM dbo.Stock</CommandText>
480 <Parameters />
481 </DbCommand>
482 </SelectCommand>
483 <UpdateCommand>
484 <DbCommand CommandType="Text" ModifiedByUser="false">
485 <CommandText>UPDATE [dbo].[Stock] SET [StockID] = @StockID, [StockDate] = @StockDate, [ProductID] = @ProductID, [SupplierID] = @SupplierID, [Quantity] = @Quantity WHERE (([StockID] = @Original_StockID) AND ([StockDate] = @Original_StockDate) AND ([ProductID] = @Original_ProductID) AND ([SupplierID] = @Original_SupplierID) AND ([Quantity] = @Original_Quantity));
486 SELECT StockID, StockDate, ProductID, SupplierID, Quantity FROM Stock WHERE (StockID = @StockID)</CommandText>
487 <Parameters>
488 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StockID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Current" />
489 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StockDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockDate" SourceColumnNullMapping="false" SourceVersion="Current" />
490 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
491 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Current" />
492 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
493 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StockID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockID" SourceColumnNullMapping="false" SourceVersion="Original" />
494 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StockDate" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StockDate" SourceColumnNullMapping="false" SourceVersion="Original" />
495 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
496 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SupplierID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierID" SourceColumnNullMapping="false" SourceVersion="Original" />
497 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
498 </Parameters>
499 </DbCommand>
500 </UpdateCommand>
501 </DbSource>
502 </MainSource>
503 <Mappings>
504 <Mapping SourceColumn="StockID" DataSetColumn="StockID" />
505 <Mapping SourceColumn="StockDate" DataSetColumn="StockDate" />
506 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
507 <Mapping SourceColumn="SupplierID" DataSetColumn="SupplierID" />
508 <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
509 </Mappings>
510 <Sources />
511 </TableAdapter>
512 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubCategoryTableAdapter" GeneratorDataComponentClassName="SubCategoryTableAdapter" Name="SubCategory" UserDataComponentName="SubCategoryTableAdapter">
513 <MainSource>
514 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.SubCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
515 <DeleteCommand>
516 <DbCommand CommandType="Text" ModifiedByUser="false">
517 <CommandText>DELETE FROM [dbo].[SubCategory] WHERE (([ID] = @Original_ID) AND ([SubCategoryName] = @Original_SubCategoryName) AND ([CategoryID] = @Original_CategoryID))</CommandText>
518 <Parameters>
519 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
520 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SubCategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
521 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
522 </Parameters>
523 </DbCommand>
524 </DeleteCommand>
525 <InsertCommand>
526 <DbCommand CommandType="Text" ModifiedByUser="false">
527 <CommandText>INSERT INTO [dbo].[SubCategory] ([SubCategoryName], [CategoryID]) VALUES (@SubCategoryName, @CategoryID);
528 SELECT ID, SubCategoryName, CategoryID FROM SubCategory WHERE (ID = SCOPE_IDENTITY())</CommandText>
529 <Parameters>
530 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SubCategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
531 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
532 </Parameters>
533 </DbCommand>
534 </InsertCommand>
535 <SelectCommand>
536 <DbCommand CommandType="Text" ModifiedByUser="false">
537 <CommandText>SELECT ID, SubCategoryName, CategoryID FROM dbo.SubCategory</CommandText>
538 <Parameters />
539 </DbCommand>
540 </SelectCommand>
541 <UpdateCommand>
542 <DbCommand CommandType="Text" ModifiedByUser="false">
543 <CommandText>UPDATE [dbo].[SubCategory] SET [SubCategoryName] = @SubCategoryName, [CategoryID] = @CategoryID WHERE (([ID] = @Original_ID) AND ([SubCategoryName] = @Original_SubCategoryName) AND ([CategoryID] = @Original_CategoryID));
544 SELECT ID, SubCategoryName, CategoryID FROM SubCategory WHERE (ID = @ID)</CommandText>
545 <Parameters>
546 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SubCategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
547 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
548 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
549 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SubCategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubCategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
550 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Original" />
551 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="[C:\USERS\RAJ\DESKTOP\POS\SALES AND INVENTORY SYSTEM (GADGETS SHOP)\BIN\DEBUG\POS_DB.MDF].dbo.SubCategory" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
552 </Parameters>
553 </DbCommand>
554 </UpdateCommand>
555 </DbSource>
556 </MainSource>
557 <Mappings>
558 <Mapping SourceColumn="ID" DataSetColumn="ID" />
559 <Mapping SourceColumn="SubCategoryName" DataSetColumn="SubCategoryName" />
560 <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
561 </Mappings>
562 <Sources />
563 </TableAdapter>
564 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SupplierTableAdapter" GeneratorDataComponentClassName="SupplierTableAdapter" Name="Supplier" UserDataComponentName="SupplierTableAdapter">
565 <MainSource>
566 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Supplier" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
567 <DeleteCommand>
568 <DbCommand CommandType="Text" ModifiedByUser="false">
569 <CommandText>DELETE FROM [dbo].[Supplier] WHERE (([SupplierId] = @Original_SupplierId) AND ([SupplierName] = @Original_SupplierName) AND ([Address] = @Original_Address) AND ([City] = @Original_City) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_ContactNo1 = 1 AND [ContactNo1] IS NULL) OR ([ContactNo1] = @Original_ContactNo1)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)))</CommandText>
570 <Parameters>
571 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SupplierId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierId" SourceColumnNullMapping="false" SourceVersion="Original" />
572 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SupplierName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Original" />
573 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
574 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
575 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
576 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactNo1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="true" SourceVersion="Original" />
577 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Original" />
578 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
579 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
580 </Parameters>
581 </DbCommand>
582 </DeleteCommand>
583 <InsertCommand>
584 <DbCommand CommandType="Text" ModifiedByUser="false">
585 <CommandText>INSERT INTO [dbo].[Supplier] ([SupplierId], [SupplierName], [Address], [City], [ContactNo], [ContactNo1], [Email], [Notes]) VALUES (@SupplierId, @SupplierName, @Address, @City, @ContactNo, @ContactNo1, @Email, @Notes);
586 SELECT SupplierId, SupplierName, Address, City, ContactNo, ContactNo1, Email, Notes FROM Supplier WHERE (SupplierId = @SupplierId)</CommandText>
587 <Parameters>
588 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SupplierId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierId" SourceColumnNullMapping="false" SourceVersion="Current" />
589 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SupplierName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Current" />
590 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
591 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
592 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
593 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Current" />
594 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
595 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
596 </Parameters>
597 </DbCommand>
598 </InsertCommand>
599 <SelectCommand>
600 <DbCommand CommandType="Text" ModifiedByUser="false">
601 <CommandText>SELECT SupplierId, SupplierName, Address, City, ContactNo, ContactNo1, Email, Notes FROM dbo.Supplier</CommandText>
602 <Parameters />
603 </DbCommand>
604 </SelectCommand>
605 <UpdateCommand>
606 <DbCommand CommandType="Text" ModifiedByUser="false">
607 <CommandText>UPDATE [dbo].[Supplier] SET [SupplierId] = @SupplierId, [SupplierName] = @SupplierName, [Address] = @Address, [City] = @City, [ContactNo] = @ContactNo, [ContactNo1] = @ContactNo1, [Email] = @Email, [Notes] = @Notes WHERE (([SupplierId] = @Original_SupplierId) AND ([SupplierName] = @Original_SupplierName) AND ([Address] = @Original_Address) AND ([City] = @Original_City) AND ([ContactNo] = @Original_ContactNo) AND ((@IsNull_ContactNo1 = 1 AND [ContactNo1] IS NULL) OR ([ContactNo1] = @Original_ContactNo1)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)));
608 SELECT SupplierId, SupplierName, Address, City, ContactNo, ContactNo1, Email, Notes FROM Supplier WHERE (SupplierId = @SupplierId)</CommandText>
609 <Parameters>
610 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@SupplierId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierId" SourceColumnNullMapping="false" SourceVersion="Current" />
611 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SupplierName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Current" />
612 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
613 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
614 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
615 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Current" />
616 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
617 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
618 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_SupplierId" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="SupplierId" SourceColumnNullMapping="false" SourceVersion="Original" />
619 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SupplierName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SupplierName" SourceColumnNullMapping="false" SourceVersion="Original" />
620 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
621 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
622 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
623 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ContactNo1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="true" SourceVersion="Original" />
624 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo1" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo1" SourceColumnNullMapping="false" SourceVersion="Original" />
625 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
626 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
627 </Parameters>
628 </DbCommand>
629 </UpdateCommand>
630 </DbSource>
631 </MainSource>
632 <Mappings>
633 <Mapping SourceColumn="SupplierId" DataSetColumn="SupplierId" />
634 <Mapping SourceColumn="SupplierName" DataSetColumn="SupplierName" />
635 <Mapping SourceColumn="Address" DataSetColumn="Address" />
636 <Mapping SourceColumn="City" DataSetColumn="City" />
637 <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
638 <Mapping SourceColumn="ContactNo1" DataSetColumn="ContactNo1" />
639 <Mapping SourceColumn="Email" DataSetColumn="Email" />
640 <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
641 </Mappings>
642 <Sources />
643 </TableAdapter>
644 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Temp_StockTableAdapter" GeneratorDataComponentClassName="Temp_StockTableAdapter" Name="Temp_Stock" UserDataComponentName="Temp_StockTableAdapter">
645 <MainSource>
646 <DbSource ConnectionRef="POS_DBConnectionString (Settings)" DbObjectName="dbo.Temp_Stock" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
647 <DeleteCommand>
648 <DbCommand CommandType="Text" ModifiedByUser="false">
649 <CommandText>DELETE FROM [dbo].[Temp_Stock] WHERE (([ID] = @Original_ID) AND ([ProductID] = @Original_ProductID) AND ([Quantity] = @Original_Quantity))</CommandText>
650 <Parameters>
651 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
652 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
653 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
654 </Parameters>
655 </DbCommand>
656 </DeleteCommand>
657 <InsertCommand>
658 <DbCommand CommandType="Text" ModifiedByUser="false">
659 <CommandText>INSERT INTO [dbo].[Temp_Stock] ([ProductID], [Quantity]) VALUES (@ProductID, @Quantity);
660 SELECT ID, ProductID, Quantity FROM Temp_Stock WHERE (ID = SCOPE_IDENTITY())</CommandText>
661 <Parameters>
662 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
663 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
664 </Parameters>
665 </DbCommand>
666 </InsertCommand>
667 <SelectCommand>
668 <DbCommand CommandType="Text" ModifiedByUser="false">
669 <CommandText>SELECT ID, ProductID, Quantity FROM dbo.Temp_Stock</CommandText>
670 <Parameters />
671 </DbCommand>
672 </SelectCommand>
673 <UpdateCommand>
674 <DbCommand CommandType="Text" ModifiedByUser="false">
675 <CommandText>UPDATE [dbo].[Temp_Stock] SET [ProductID] = @ProductID, [Quantity] = @Quantity WHERE (([ID] = @Original_ID) AND ([ProductID] = @Original_ProductID) AND ([Quantity] = @Original_Quantity));
676 SELECT ID, ProductID, Quantity FROM Temp_Stock WHERE (ID = @ID)</CommandText>
677 <Parameters>
678 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Current" />
679 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
680 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
681 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ProductID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ProductID" SourceColumnNullMapping="false" SourceVersion="Original" />
682 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Quantity" SourceColumnNullMapping="false" SourceVersion="Original" />
683 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="[C:\USERS\RAJ\DESKTOP\POS\SALES AND INVENTORY SYSTEM (GADGETS SHOP)\BIN\DEBUG\POS_DB.MDF].dbo.Temp_Stock" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
684 </Parameters>
685 </DbCommand>
686 </UpdateCommand>
687 </DbSource>
688 </MainSource>
689 <Mappings>
690 <Mapping SourceColumn="ID" DataSetColumn="ID" />
691 <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
692 <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
693 </Mappings>
694 <Sources />
695 </TableAdapter>
696 </Tables>
697 <Sources />
698 </DataSource>
699 </xs:appinfo>
700 </xs:annotation>
701 <xs:element name="POS_DBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:EnforceConstraints="False" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="POS_DBDataSet" msprop:Generator_UserDSName="POS_DBDataSet">
702 <xs:complexType>
703 <xs:choice minOccurs="0" maxOccurs="unbounded">
704 <xs:element name="Category" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_TableVarName="tableCategory" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_TablePropName="Category" msprop:Generator_RowDeletingName="CategoryRowDeleting" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_RowClassName="CategoryRow" msprop:Generator_UserTableName="Category" msprop:Generator_RowEvArgName="CategoryRowChangeEvent">
705 <xs:complexType>
706 <xs:sequence>
707 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
708 <xs:element name="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn" msprop:Generator_UserColumnName="CategoryName">
709 <xs:simpleType>
710 <xs:restriction base="xs:string">
711 <xs:maxLength value="250" />
712 </xs:restriction>
713 </xs:simpleType>
714 </xs:element>
715 </xs:sequence>
716 </xs:complexType>
717 </xs:element>
718 <xs:element name="Customer" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_TablePropName="Customer" msprop:Generator_RowDeletingName="CustomerRowDeleting" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_RowClassName="CustomerRow" msprop:Generator_UserTableName="Customer" msprop:Generator_RowEvArgName="CustomerRowChangeEvent">
719 <xs:complexType>
720 <xs:sequence>
721 <xs:element name="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" msprop:Generator_UserColumnName="CustomerId">
722 <xs:simpleType>
723 <xs:restriction base="xs:string">
724 <xs:maxLength value="10" />
725 </xs:restriction>
726 </xs:simpleType>
727 </xs:element>
728 <xs:element name="CustomerName" msprop:Generator_ColumnVarNameInTable="columnCustomerName" msprop:Generator_ColumnPropNameInRow="CustomerName" msprop:Generator_ColumnPropNameInTable="CustomerNameColumn" msprop:Generator_UserColumnName="CustomerName">
729 <xs:simpleType>
730 <xs:restriction base="xs:string">
731 <xs:maxLength value="100" />
732 </xs:restriction>
733 </xs:simpleType>
734 </xs:element>
735 <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
736 <xs:simpleType>
737 <xs:restriction base="xs:string">
738 <xs:maxLength value="2147483647" />
739 </xs:restriction>
740 </xs:simpleType>
741 </xs:element>
742 <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
743 <xs:simpleType>
744 <xs:restriction base="xs:string">
745 <xs:maxLength value="250" />
746 </xs:restriction>
747 </xs:simpleType>
748 </xs:element>
749 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
750 <xs:simpleType>
751 <xs:restriction base="xs:string">
752 <xs:maxLength value="15" />
753 </xs:restriction>
754 </xs:simpleType>
755 </xs:element>
756 <xs:element name="ContactNo1" msprop:Generator_ColumnVarNameInTable="columnContactNo1" msprop:Generator_ColumnPropNameInRow="ContactNo1" msprop:Generator_ColumnPropNameInTable="ContactNo1Column" msprop:Generator_UserColumnName="ContactNo1" minOccurs="0">
757 <xs:simpleType>
758 <xs:restriction base="xs:string">
759 <xs:maxLength value="15" />
760 </xs:restriction>
761 </xs:simpleType>
762 </xs:element>
763 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
764 <xs:simpleType>
765 <xs:restriction base="xs:string">
766 <xs:maxLength value="250" />
767 </xs:restriction>
768 </xs:simpleType>
769 </xs:element>
770 <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
771 <xs:simpleType>
772 <xs:restriction base="xs:string">
773 <xs:maxLength value="2147483647" />
774 </xs:restriction>
775 </xs:simpleType>
776 </xs:element>
777 </xs:sequence>
778 </xs:complexType>
779 </xs:element>
780 <xs:element name="Invoice_Info" msprop:Generator_TableClassName="Invoice_InfoDataTable" msprop:Generator_TableVarName="tableInvoice_Info" msprop:Generator_RowChangedName="Invoice_InfoRowChanged" msprop:Generator_TablePropName="Invoice_Info" msprop:Generator_RowDeletingName="Invoice_InfoRowDeleting" msprop:Generator_RowChangingName="Invoice_InfoRowChanging" msprop:Generator_RowEvHandlerName="Invoice_InfoRowChangeEventHandler" msprop:Generator_RowDeletedName="Invoice_InfoRowDeleted" msprop:Generator_RowClassName="Invoice_InfoRow" msprop:Generator_UserTableName="Invoice_Info" msprop:Generator_RowEvArgName="Invoice_InfoRowChangeEvent">
781 <xs:complexType>
782 <xs:sequence>
783 <xs:element name="InvoiceNo" msprop:Generator_ColumnVarNameInTable="columnInvoiceNo" msprop:Generator_ColumnPropNameInRow="InvoiceNo" msprop:Generator_ColumnPropNameInTable="InvoiceNoColumn" msprop:Generator_UserColumnName="InvoiceNo">
784 <xs:simpleType>
785 <xs:restriction base="xs:string">
786 <xs:maxLength value="10" />
787 </xs:restriction>
788 </xs:simpleType>
789 </xs:element>
790 <xs:element name="InvoiceDate" msprop:Generator_ColumnVarNameInTable="columnInvoiceDate" msprop:Generator_ColumnPropNameInRow="InvoiceDate" msprop:Generator_ColumnPropNameInTable="InvoiceDateColumn" msprop:Generator_UserColumnName="InvoiceDate">
791 <xs:simpleType>
792 <xs:restriction base="xs:string">
793 <xs:maxLength value="30" />
794 </xs:restriction>
795 </xs:simpleType>
796 </xs:element>
797 <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID">
798 <xs:simpleType>
799 <xs:restriction base="xs:string">
800 <xs:maxLength value="10" />
801 </xs:restriction>
802 </xs:simpleType>
803 </xs:element>
804 <xs:element name="SubTotal" msprop:Generator_ColumnVarNameInTable="columnSubTotal" msprop:Generator_ColumnPropNameInRow="SubTotal" msprop:Generator_ColumnPropNameInTable="SubTotalColumn" msprop:Generator_UserColumnName="SubTotal" type="xs:double" />
805 <xs:element name="VATPer" msprop:Generator_ColumnVarNameInTable="columnVATPer" msprop:Generator_ColumnPropNameInRow="VATPer" msprop:Generator_ColumnPropNameInTable="VATPerColumn" msprop:Generator_UserColumnName="VATPer" type="xs:double" />
806 <xs:element name="VATAmount" msprop:Generator_ColumnVarNameInTable="columnVATAmount" msprop:Generator_ColumnPropNameInRow="VATAmount" msprop:Generator_ColumnPropNameInTable="VATAmountColumn" msprop:Generator_UserColumnName="VATAmount" type="xs:double" />
807 <xs:element name="DiscountPer" msprop:Generator_ColumnVarNameInTable="columnDiscountPer" msprop:Generator_ColumnPropNameInRow="DiscountPer" msprop:Generator_ColumnPropNameInTable="DiscountPerColumn" msprop:Generator_UserColumnName="DiscountPer" type="xs:double" />
808 <xs:element name="DiscountAmount" msprop:Generator_ColumnVarNameInTable="columnDiscountAmount" msprop:Generator_ColumnPropNameInRow="DiscountAmount" msprop:Generator_ColumnPropNameInTable="DiscountAmountColumn" msprop:Generator_UserColumnName="DiscountAmount" type="xs:double" />
809 <xs:element name="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" msprop:Generator_UserColumnName="GrandTotal" type="xs:double" />
810 <xs:element name="TotalPayment" msprop:Generator_ColumnVarNameInTable="columnTotalPayment" msprop:Generator_ColumnPropNameInRow="TotalPayment" msprop:Generator_ColumnPropNameInTable="TotalPaymentColumn" msprop:Generator_UserColumnName="TotalPayment" type="xs:double" />
811 <xs:element name="PaymentDue" msprop:Generator_ColumnVarNameInTable="columnPaymentDue" msprop:Generator_ColumnPropNameInRow="PaymentDue" msprop:Generator_ColumnPropNameInTable="PaymentDueColumn" msprop:Generator_UserColumnName="PaymentDue" type="xs:double" />
812 <xs:element name="PaymentType" msprop:Generator_ColumnVarNameInTable="columnPaymentType" msprop:Generator_ColumnPropNameInRow="PaymentType" msprop:Generator_ColumnPropNameInTable="PaymentTypeColumn" msprop:Generator_UserColumnName="PaymentType">
813 <xs:simpleType>
814 <xs:restriction base="xs:string">
815 <xs:maxLength value="100" />
816 </xs:restriction>
817 </xs:simpleType>
818 </xs:element>
819 <xs:element name="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" msprop:Generator_UserColumnName="Status">
820 <xs:simpleType>
821 <xs:restriction base="xs:string">
822 <xs:maxLength value="100" />
823 </xs:restriction>
824 </xs:simpleType>
825 </xs:element>
826 </xs:sequence>
827 </xs:complexType>
828 </xs:element>
829 <xs:element name="Product" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_TableVarName="tableProduct" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_TablePropName="Product" msprop:Generator_RowDeletingName="ProductRowDeleting" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_RowClassName="ProductRow" msprop:Generator_UserTableName="Product" msprop:Generator_RowEvArgName="ProductRowChangeEvent">
830 <xs:complexType>
831 <xs:sequence>
832 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
833 <xs:simpleType>
834 <xs:restriction base="xs:string">
835 <xs:maxLength value="10" />
836 </xs:restriction>
837 </xs:simpleType>
838 </xs:element>
839 <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
840 <xs:simpleType>
841 <xs:restriction base="xs:string">
842 <xs:maxLength value="2147483647" />
843 </xs:restriction>
844 </xs:simpleType>
845 </xs:element>
846 <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:int" />
847 <xs:element name="SubCategoryID" msprop:Generator_ColumnVarNameInTable="columnSubCategoryID" msprop:Generator_ColumnPropNameInRow="SubCategoryID" msprop:Generator_ColumnPropNameInTable="SubCategoryIDColumn" msprop:Generator_UserColumnName="SubCategoryID" type="xs:int" />
848 <xs:element name="Features" msprop:Generator_ColumnVarNameInTable="columnFeatures" msprop:Generator_ColumnPropNameInRow="Features" msprop:Generator_ColumnPropNameInTable="FeaturesColumn" msprop:Generator_UserColumnName="Features" minOccurs="0">
849 <xs:simpleType>
850 <xs:restriction base="xs:string">
851 <xs:maxLength value="2147483647" />
852 </xs:restriction>
853 </xs:simpleType>
854 </xs:element>
855 <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:double" />
856 <xs:element name="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnPropNameInTable="ImageColumn" msprop:Generator_UserColumnName="Image" type="xs:base64Binary" />
857 </xs:sequence>
858 </xs:complexType>
859 </xs:element>
860 <xs:element name="ProductSold" msprop:Generator_TableClassName="ProductSoldDataTable" msprop:Generator_TableVarName="tableProductSold" msprop:Generator_RowChangedName="ProductSoldRowChanged" msprop:Generator_TablePropName="ProductSold" msprop:Generator_RowDeletingName="ProductSoldRowDeleting" msprop:Generator_RowChangingName="ProductSoldRowChanging" msprop:Generator_RowEvHandlerName="ProductSoldRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductSoldRowDeleted" msprop:Generator_RowClassName="ProductSoldRow" msprop:Generator_UserTableName="ProductSold" msprop:Generator_RowEvArgName="ProductSoldRowChangeEvent">
861 <xs:complexType>
862 <xs:sequence>
863 <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
864 <xs:element name="InvoiceNo" msprop:Generator_ColumnVarNameInTable="columnInvoiceNo" msprop:Generator_ColumnPropNameInRow="InvoiceNo" msprop:Generator_ColumnPropNameInTable="InvoiceNoColumn" msprop:Generator_UserColumnName="InvoiceNo">
865 <xs:simpleType>
866 <xs:restriction base="xs:string">
867 <xs:maxLength value="10" />
868 </xs:restriction>
869 </xs:simpleType>
870 </xs:element>
871 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
872 <xs:simpleType>
873 <xs:restriction base="xs:string">
874 <xs:maxLength value="10" />
875 </xs:restriction>
876 </xs:simpleType>
877 </xs:element>
878 <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
879 <xs:simpleType>
880 <xs:restriction base="xs:string">
881 <xs:maxLength value="250" />
882 </xs:restriction>
883 </xs:simpleType>
884 </xs:element>
885 <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:double" />
886 <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:int" />
887 <xs:element name="TotalAmount" msprop:Generator_ColumnVarNameInTable="columnTotalAmount" msprop:Generator_ColumnPropNameInRow="TotalAmount" msprop:Generator_ColumnPropNameInTable="TotalAmountColumn" msprop:Generator_UserColumnName="TotalAmount" type="xs:double" />
888 </xs:sequence>
889 </xs:complexType>
890 </xs:element>
891 <xs:element name="Registration" msprop:Generator_TableClassName="RegistrationDataTable" msprop:Generator_TableVarName="tableRegistration" msprop:Generator_RowChangedName="RegistrationRowChanged" msprop:Generator_TablePropName="Registration" msprop:Generator_RowDeletingName="RegistrationRowDeleting" msprop:Generator_RowChangingName="RegistrationRowChanging" msprop:Generator_RowEvHandlerName="RegistrationRowChangeEventHandler" msprop:Generator_RowDeletedName="RegistrationRowDeleted" msprop:Generator_RowClassName="RegistrationRow" msprop:Generator_UserTableName="Registration" msprop:Generator_RowEvArgName="RegistrationRowChangeEvent">
892 <xs:complexType>
893 <xs:sequence>
894 <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
895 <xs:simpleType>
896 <xs:restriction base="xs:string">
897 <xs:maxLength value="30" />
898 </xs:restriction>
899 </xs:simpleType>
900 </xs:element>
901 <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password">
902 <xs:simpleType>
903 <xs:restriction base="xs:string">
904 <xs:maxLength value="30" />
905 </xs:restriction>
906 </xs:simpleType>
907 </xs:element>
908 <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
909 <xs:simpleType>
910 <xs:restriction base="xs:string">
911 <xs:maxLength value="250" />
912 </xs:restriction>
913 </xs:simpleType>
914 </xs:element>
915 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
916 <xs:simpleType>
917 <xs:restriction base="xs:string">
918 <xs:maxLength value="15" />
919 </xs:restriction>
920 </xs:simpleType>
921 </xs:element>
922 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
923 <xs:simpleType>
924 <xs:restriction base="xs:string">
925 <xs:maxLength value="250" />
926 </xs:restriction>
927 </xs:simpleType>
928 </xs:element>
929 <xs:element name="JoiningDate" msprop:Generator_ColumnVarNameInTable="columnJoiningDate" msprop:Generator_ColumnPropNameInRow="JoiningDate" msprop:Generator_ColumnPropNameInTable="JoiningDateColumn" msprop:Generator_UserColumnName="JoiningDate" minOccurs="0">
930 <xs:simpleType>
931 <xs:restriction base="xs:string">
932 <xs:maxLength value="50" />
933 </xs:restriction>
934 </xs:simpleType>
935 </xs:element>
936 </xs:sequence>
937 </xs:complexType>
938 </xs:element>
939 <xs:element name="Stock" msprop:Generator_TableClassName="StockDataTable" msprop:Generator_TableVarName="tableStock" msprop:Generator_RowChangedName="StockRowChanged" msprop:Generator_TablePropName="Stock" msprop:Generator_RowDeletingName="StockRowDeleting" msprop:Generator_RowChangingName="StockRowChanging" msprop:Generator_RowEvHandlerName="StockRowChangeEventHandler" msprop:Generator_RowDeletedName="StockRowDeleted" msprop:Generator_RowClassName="StockRow" msprop:Generator_UserTableName="Stock" msprop:Generator_RowEvArgName="StockRowChangeEvent">
940 <xs:complexType>
941 <xs:sequence>
942 <xs:element name="StockID" msprop:Generator_ColumnVarNameInTable="columnStockID" msprop:Generator_ColumnPropNameInRow="StockID" msprop:Generator_ColumnPropNameInTable="StockIDColumn" msprop:Generator_UserColumnName="StockID">
943 <xs:simpleType>
944 <xs:restriction base="xs:string">
945 <xs:maxLength value="10" />
946 </xs:restriction>
947 </xs:simpleType>
948 </xs:element>
949 <xs:element name="StockDate" msprop:Generator_ColumnVarNameInTable="columnStockDate" msprop:Generator_ColumnPropNameInRow="StockDate" msprop:Generator_ColumnPropNameInTable="StockDateColumn" msprop:Generator_UserColumnName="StockDate">
950 <xs:simpleType>
951 <xs:restriction base="xs:string">
952 <xs:maxLength value="30" />
953 </xs:restriction>
954 </xs:simpleType>
955 </xs:element>
956 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
957 <xs:simpleType>
958 <xs:restriction base="xs:string">
959 <xs:maxLength value="10" />
960 </xs:restriction>
961 </xs:simpleType>
962 </xs:element>
963 <xs:element name="SupplierID" msprop:Generator_ColumnVarNameInTable="columnSupplierID" msprop:Generator_ColumnPropNameInRow="SupplierID" msprop:Generator_ColumnPropNameInTable="SupplierIDColumn" msprop:Generator_UserColumnName="SupplierID">
964 <xs:simpleType>
965 <xs:restriction base="xs:string">
966 <xs:maxLength value="10" />
967 </xs:restriction>
968 </xs:simpleType>
969 </xs:element>
970 <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:int" />
971 </xs:sequence>
972 </xs:complexType>
973 </xs:element>
974 <xs:element name="SubCategory" msprop:Generator_TableClassName="SubCategoryDataTable" msprop:Generator_TableVarName="tableSubCategory" msprop:Generator_RowChangedName="SubCategoryRowChanged" msprop:Generator_TablePropName="SubCategory" msprop:Generator_RowDeletingName="SubCategoryRowDeleting" msprop:Generator_RowChangingName="SubCategoryRowChanging" msprop:Generator_RowEvHandlerName="SubCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="SubCategoryRowDeleted" msprop:Generator_RowClassName="SubCategoryRow" msprop:Generator_UserTableName="SubCategory" msprop:Generator_RowEvArgName="SubCategoryRowChangeEvent">
975 <xs:complexType>
976 <xs:sequence>
977 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
978 <xs:element name="SubCategoryName" msprop:Generator_ColumnVarNameInTable="columnSubCategoryName" msprop:Generator_ColumnPropNameInRow="SubCategoryName" msprop:Generator_ColumnPropNameInTable="SubCategoryNameColumn" msprop:Generator_UserColumnName="SubCategoryName">
979 <xs:simpleType>
980 <xs:restriction base="xs:string">
981 <xs:maxLength value="250" />
982 </xs:restriction>
983 </xs:simpleType>
984 </xs:element>
985 <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:int" />
986 </xs:sequence>
987 </xs:complexType>
988 </xs:element>
989 <xs:element name="Supplier" msprop:Generator_TableClassName="SupplierDataTable" msprop:Generator_TableVarName="tableSupplier" msprop:Generator_RowChangedName="SupplierRowChanged" msprop:Generator_TablePropName="Supplier" msprop:Generator_RowDeletingName="SupplierRowDeleting" msprop:Generator_RowChangingName="SupplierRowChanging" msprop:Generator_RowEvHandlerName="SupplierRowChangeEventHandler" msprop:Generator_RowDeletedName="SupplierRowDeleted" msprop:Generator_RowClassName="SupplierRow" msprop:Generator_UserTableName="Supplier" msprop:Generator_RowEvArgName="SupplierRowChangeEvent">
990 <xs:complexType>
991 <xs:sequence>
992 <xs:element name="SupplierId" msprop:Generator_ColumnVarNameInTable="columnSupplierId" msprop:Generator_ColumnPropNameInRow="SupplierId" msprop:Generator_ColumnPropNameInTable="SupplierIdColumn" msprop:Generator_UserColumnName="SupplierId">
993 <xs:simpleType>
994 <xs:restriction base="xs:string">
995 <xs:maxLength value="10" />
996 </xs:restriction>
997 </xs:simpleType>
998 </xs:element>
999 <xs:element name="SupplierName" msprop:Generator_ColumnVarNameInTable="columnSupplierName" msprop:Generator_ColumnPropNameInRow="SupplierName" msprop:Generator_ColumnPropNameInTable="SupplierNameColumn" msprop:Generator_UserColumnName="SupplierName">
1000 <xs:simpleType>
1001 <xs:restriction base="xs:string">
1002 <xs:maxLength value="250" />
1003 </xs:restriction>
1004 </xs:simpleType>
1005 </xs:element>
1006 <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
1007 <xs:simpleType>
1008 <xs:restriction base="xs:string">
1009 <xs:maxLength value="250" />
1010 </xs:restriction>
1011 </xs:simpleType>
1012 </xs:element>
1013 <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
1014 <xs:simpleType>
1015 <xs:restriction base="xs:string">
1016 <xs:maxLength value="250" />
1017 </xs:restriction>
1018 </xs:simpleType>
1019 </xs:element>
1020 <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
1021 <xs:simpleType>
1022 <xs:restriction base="xs:string">
1023 <xs:maxLength value="15" />
1024 </xs:restriction>
1025 </xs:simpleType>
1026 </xs:element>
1027 <xs:element name="ContactNo1" msprop:Generator_ColumnVarNameInTable="columnContactNo1" msprop:Generator_ColumnPropNameInRow="ContactNo1" msprop:Generator_ColumnPropNameInTable="ContactNo1Column" msprop:Generator_UserColumnName="ContactNo1" minOccurs="0">
1028 <xs:simpleType>
1029 <xs:restriction base="xs:string">
1030 <xs:maxLength value="15" />
1031 </xs:restriction>
1032 </xs:simpleType>
1033 </xs:element>
1034 <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
1035 <xs:simpleType>
1036 <xs:restriction base="xs:string">
1037 <xs:maxLength value="250" />
1038 </xs:restriction>
1039 </xs:simpleType>
1040 </xs:element>
1041 <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes" minOccurs="0">
1042 <xs:simpleType>
1043 <xs:restriction base="xs:string">
1044 <xs:maxLength value="2147483647" />
1045 </xs:restriction>
1046 </xs:simpleType>
1047 </xs:element>
1048 </xs:sequence>
1049 </xs:complexType>
1050 </xs:element>
1051 <xs:element name="Temp_Stock" msprop:Generator_TableClassName="Temp_StockDataTable" msprop:Generator_TableVarName="tableTemp_Stock" msprop:Generator_RowChangedName="Temp_StockRowChanged" msprop:Generator_TablePropName="Temp_Stock" msprop:Generator_RowDeletingName="Temp_StockRowDeleting" msprop:Generator_RowChangingName="Temp_StockRowChanging" msprop:Generator_RowEvHandlerName="Temp_StockRowChangeEventHandler" msprop:Generator_RowDeletedName="Temp_StockRowDeleted" msprop:Generator_RowClassName="Temp_StockRow" msprop:Generator_UserTableName="Temp_Stock" msprop:Generator_RowEvArgName="Temp_StockRowChangeEvent">
1052 <xs:complexType>
1053 <xs:sequence>
1054 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
1055 <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID">
1056 <xs:simpleType>
1057 <xs:restriction base="xs:string">
1058 <xs:maxLength value="10" />
1059 </xs:restriction>
1060 </xs:simpleType>
1061 </xs:element>
1062 <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:int" />
1063 </xs:sequence>
1064 </xs:complexType>
1065 </xs:element>
1066 </xs:choice>
1067 </xs:complexType>
1068 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
1069 <xs:selector xpath=".//mstns:Category" />
1070 <xs:field xpath="mstns:ID" />
1071 </xs:unique>
1072 <xs:unique name="Customer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1073 <xs:selector xpath=".//mstns:Customer" />
1074 <xs:field xpath="mstns:CustomerId" />
1075 </xs:unique>
1076 <xs:unique name="Invoice_Info_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1077 <xs:selector xpath=".//mstns:Invoice_Info" />
1078 <xs:field xpath="mstns:InvoiceNo" />
1079 </xs:unique>
1080 <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1081 <xs:selector xpath=".//mstns:Product" />
1082 <xs:field xpath="mstns:ProductID" />
1083 </xs:unique>
1084 <xs:unique name="ProductSold_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1085 <xs:selector xpath=".//mstns:ProductSold" />
1086 <xs:field xpath="mstns:Id" />
1087 </xs:unique>
1088 <xs:unique name="Registration_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1089 <xs:selector xpath=".//mstns:Registration" />
1090 <xs:field xpath="mstns:UserName" />
1091 </xs:unique>
1092 <xs:unique name="Stock_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1093 <xs:selector xpath=".//mstns:Stock" />
1094 <xs:field xpath="mstns:StockID" />
1095 </xs:unique>
1096 <xs:unique name="SubCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1097 <xs:selector xpath=".//mstns:SubCategory" />
1098 <xs:field xpath="mstns:ID" />
1099 </xs:unique>
1100 <xs:unique name="Supplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1101 <xs:selector xpath=".//mstns:Supplier" />
1102 <xs:field xpath="mstns:SupplierId" />
1103 </xs:unique>
1104 <xs:unique name="Temp_Stock_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
1105 <xs:selector xpath=".//mstns:Temp_Stock" />
1106 <xs:field xpath="mstns:ID" />
1107 </xs:unique>
1108 </xs:element>
1109 <xs:annotation>
1110 <xs:appinfo>
1111 <msdata:Relationship name="FK_Table_Customer" msdata:parent="Customer" msdata:child="Invoice_Info" msdata:parentkey="CustomerId" msdata:childkey="CustomerID" msprop:Generator_UserChildTable="Invoice_Info" msprop:Generator_ChildPropName="GetInvoice_InfoRows" msprop:Generator_UserRelationName="FK_Table_Customer" msprop:Generator_RelationVarName="relationFK_Table_Customer" msprop:Generator_UserParentTable="Customer" msprop:Generator_ParentPropName="CustomerRow" />
1112 <msdata:Relationship name="FK_Product_ToCategory" msdata:parent="Category" msdata:child="Product" msdata:parentkey="ID" msdata:childkey="CategoryID" msprop:Generator_UserChildTable="Product" msprop:Generator_ChildPropName="GetProductRows" msprop:Generator_UserRelationName="FK_Product_ToCategory" msprop:Generator_RelationVarName="relationFK_Product_ToCategory" msprop:Generator_UserParentTable="Category" msprop:Generator_ParentPropName="CategoryRow" />
1113 <msdata:Relationship name="FK_Product_ToSubCategory" msdata:parent="SubCategory" msdata:child="Product" msdata:parentkey="ID" msdata:childkey="SubCategoryID" msprop:Generator_UserChildTable="Product" msprop:Generator_ChildPropName="GetProductRows" msprop:Generator_UserRelationName="FK_Product_ToSubCategory" msprop:Generator_ParentPropName="SubCategoryRow" msprop:Generator_RelationVarName="relationFK_Product_ToSubCategory" msprop:Generator_UserParentTable="SubCategory" />
1114 <msdata:Relationship name="FK_ProductSold_Product" msdata:parent="Product" msdata:child="ProductSold" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="ProductSold" msprop:Generator_ChildPropName="GetProductSoldRows" msprop:Generator_UserRelationName="FK_ProductSold_Product" msprop:Generator_RelationVarName="relationFK_ProductSold_Product" msprop:Generator_UserParentTable="Product" msprop:Generator_ParentPropName="ProductRow" />
1115 <msdata:Relationship name="FK_Table_InvoiceInfo" msdata:parent="Invoice_Info" msdata:child="ProductSold" msdata:parentkey="InvoiceNo" msdata:childkey="InvoiceNo" msprop:Generator_UserChildTable="ProductSold" msprop:Generator_ChildPropName="GetProductSoldRows" msprop:Generator_UserRelationName="FK_Table_InvoiceInfo" msprop:Generator_RelationVarName="relationFK_Table_InvoiceInfo" msprop:Generator_UserParentTable="Invoice_Info" msprop:Generator_ParentPropName="Invoice_InfoRow" />
1116 <msdata:Relationship name="FK_Stock_Product" msdata:parent="Product" msdata:child="Stock" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Generator_UserChildTable="Stock" msprop:Generator_ChildPropName="GetStockRows" msprop:Generator_UserRelationName="FK_Stock_Product" msprop:Generator_RelationVarName="relationFK_Stock_Product" msprop:Generator_UserParentTable="Product" msprop:Generator_ParentPropName="ProductRow" />
1117 <msdata:Relationship name="FK_Stock_Supplier" msdata:parent="Supplier" msdata:child="Stock" msdata:parentkey="SupplierId" msdata:childkey="SupplierID" msprop:Generator_UserChildTable="Stock" msprop:Generator_ChildPropName="GetStockRows" msprop:Generator_UserRelationName="FK_Stock_Supplier" msprop:Generator_ParentPropName="SupplierRow" msprop:Generator_RelationVarName="relationFK_Stock_Supplier" msprop:Generator_UserParentTable="Supplier" />
1118 <msdata:Relationship name="FK_SubCategory_ToCategory" msdata:parent="Category" msdata:child="SubCategory" msdata:parentkey="ID" msdata:childkey="CategoryID" msprop:Generator_UserChildTable="SubCategory" msprop:Generator_ChildPropName="GetSubCategoryRows" msprop:Generator_UserRelationName="FK_SubCategory_ToCategory" msprop:Generator_RelationVarName="relationFK_SubCategory_ToCategory" msprop:Generator_UserParentTable="Category" msprop:Generator_ParentPropName="CategoryRow" />
1119 </xs:appinfo>
1120 </xs:annotation>
1121 </xs:schema>